Microsoft Commands
- Version: 1.6.1
- Official
OpenBots Command group containing Microsoft Interop commands (Excel, Outlook, Word).
OpenBots.Commands.Microsoft \ Excel Create Pivot Table Command
Command: Excel Create Pivot Table Command
This command creates a Pivot Table from an Excel Range or Table.
Parameters
Excel Instance Name
Enter the unique instance that was specified in the **Create Application** command.
Required
Excel Data Source Worksheet
Enter the name of the Worksheet containing the Excel Table/Range being used to create the Pivot Table.
Required
Excel Data Source Type
Indicate whether to the data source of the Pivot Table should come from an Excel Table or Range.
Required
Excel Range/Table Name
Enter the Range or the name of the Excel Table to extract data from for the Pivot Table.
Required
Pivot Table Worksheet
Enter the name of the Worksheet where the Pivot Table will be set.
Required
Pivot Table Name
Enter the name of the new Pivot Table to be created.
Required
Cell Location
Enter the location where the Pivot Table will be set.
Required
Private (Optional)
Optional field to mark the command as private (data sensitive) in order to avoid its logging.
Error Handling
Optional field for how to handle errors encountered.
Required
Comment Field (Optional)
Optional field to enter a custom comment which could potentially describe this command or the need for this command, if required.
Other Commands
Word Close Application Command
Word Create Application Command
Word Append Data Table Command
Get Outlook Email Attachments Command
Get Outlook Email Property Command
Move Copy Outlook Email Command
Reply To Outlook Email Command
Excel Close Application Command
Excel Create Application Command
Excel Split Range By Column Command
Excel Save Workbook As Command
Excel Create Pivot Table Command
Excel Refresh Pivot Table Command
Excel Get Last Row Index Command
Excel Add Table Column Command
Documentation